Celestin Apprentice 7/Apprentice-Release7.iso/Demos/A.D. Software/OOFILE 1.3b4d6.sit/OOFILE 1.3b4d6/MacCodeWarriorDemo1.3b4d6/docs/results/ooftst07.out-bad

Text File | 1997-04-03 | 11.9 KB | 613 lines

OOFILE Validation Suite - Test 7
Simple test to demonstrate comparative searches
using a database similar to ooftest2 but with lots of indexed fields
Dumping database in key order by LongUnsigned (reverse of Salary)
Last Name   Other names LongUnsigned

DENT    Trissa  4294957296
Taylor  Ken 4294959795
Denton  Andy    4294962295
Smith   John    4294965295


Retrieving Andy Denton by ShortUnsigned == 25,000:
Last Name   Other names ShortUnsigned

Denton  Andy    25000


Finding LongUnsigned between 4294962294 and 4294967295
Last Name   Other names LongUnsigned

Denton  Andy    4294962295
Smith   John    4294965295


Dumping database in key order by Last Name
Last Name   Other names Last Name

DENT    Trissa  DENT
Denton  Andy    Denton
Smith   John    Smith
Taylor  Ken Taylor


Finding Last Name starting with DE
Last Name   Other names Last Name

DENT    Trissa  DENT
Denton  Andy    Denton


Finding Last Name == Dent
Last Name   Other names Last Name

DENT    Trissa  DENT


Finding Last Name < Dent
Last Name   Other names Last Name



Finding Last Name <= Dent
Last Name   Other names Last Name

DENT    Trissa  DENT


Finding Last Name > Dent
Last Name   Other names Last Name

Denton  Andy    Denton
Smith   John    Smith
Taylor  Ken Taylor


Finding Last Name >= Dent
Last Name   Other names Last Name

DENT    Trissa  DENT
Denton  Andy    Denton
Smith   John    Smith
Taylor  Ken Taylor


Finding Last Name between Dent and Denton
Last Name   Other names Last Name

DENT    Trissa  DENT
Denton  Andy    Denton


Finding Last Name outside Dent to Denton
Last Name   Other names Last Name

Smith   John    Smith
Taylor  Ken Taylor


Dumping database in key order by Other names
Last Name   Other names Other names

Denton  Andy    Andy
Smith   John    John
Taylor  Ken Ken
DENT    Trissa  Trissa


Finding Other names starting with J
Last Name   Other names Other names

Smith   John    John


Finding Other names == Andy
Last Name   Other names Other names

Denton  Andy    Andy


Finding Other names < Andy
Last Name   Other names Other names



Finding Other names <= Andy
Last Name   Other names Other names

Denton  Andy    Andy


Finding Other names > Andy
Last Name   Other names Other names

Smith   John    John
Taylor  Ken Ken
DENT    Trissa  Trissa


Finding Other names >= Andy
Last Name   Other names Other names

Denton  Andy    Andy
Smith   John    John
Taylor  Ken Ken
DENT    Trissa  Trissa


Finding Other names between Andy and Kell
Last Name   Other names Other names

Denton  Andy    Andy
Smith   John    John


Finding Other names outside Andy to Kell
Last Name   Other names Other names

Taylor  Ken Ken
DENT    Trissa  Trissa


Dumping database in key order by SalaryShort
Last Name   Other names SalaryShort

Smith   John    2000
Denton  Andy    5000
Taylor  Ken 7500
DENT    Trissa  9999


Retrieving Andy Denton by SalaryShort = 5000:
Last Name   Other names SalaryShort

Denton  Andy    5000


Retrieving John Smith by SalaryShort < 5000:
Last Name   Other names SalaryShort

Smith   John    2000


Retrieving Smith & Andy Denton by SalaryShort <= 5000:
Last Name   Other names SalaryShort

Denton  Andy    5000
Smith   John    2000


Retrieving Taylor & Trissa Dent by SalaryShort > 5000:
Last Name   Other names SalaryShort

Taylor  Ken 7500
DENT    Trissa  9999


Same search with >=5000 (should also get Andy Denton):
Last Name   Other names SalaryShort

Denton  Andy    5000
Taylor  Ken 7500
DENT    Trissa  9999


Finding SalaryShort between 5000 and 7500
Last Name   Other names SalaryShort

Denton  Andy    5000
Taylor  Ken 7500


Finding SalaryShort outside 5000 to 7500
Last Name   Other names SalaryShort

Smith   John    2000
DENT    Trissa  9999


done
Dumping database in key order by SalaryShortNoDup
Last Name   Other names SalaryShortNoDup

Smith   John    2000
Denton  Andy    5000
Taylor  Ken 7500
DENT    Trissa  9999


Retrieving Andy Denton by SalaryShortNoDup = 5000:
Last Name   Other names SalaryShortNoDup



Retrieving John Smith by SalaryShortNoDup < 5000:
Last Name   Other names SalaryShortNoDup

Smith   John    2000


Retrieving Smith & Andy Denton by SalaryShortNoDup <= 5000:
Last Name   Other names SalaryShortNoDup

Denton  Andy    5000
Smith   John    2000


Retrieving Taylor & Trissa Dent by SalaryShortNoDup > 5000:
Last Name   Other names SalaryShortNoDup

Taylor  Ken 7500
DENT    Trissa  9999


Same search with >=5000 (should also get Andy Denton):
Last Name   Other names SalaryShortNoDup

Denton  Andy    5000
Taylor  Ken 7500
DENT    Trissa  9999


Finding SalaryShortNoDup between 5000 and 7500
Last Name   Other names SalaryShortNoDup

Denton  Andy    5000
Taylor  Ken 7500


Finding SalaryShortNoDup outside 5000 to 7500
Last Name   Other names SalaryShortNoDup

Smith   John    2000
DENT    Trissa  9999


done
Dumping database in key order by Salary
Last Name   Other names Salary

Smith   John    2000
Denton  Andy    5000
Taylor  Ken 7500
DENT    Trissa  9999


Retrieving Andy Denton by Salary = 5000:
Last Name   Other names Salary

Denton  Andy    5000


Retrieving John Smith by Salary < 5000:
Last Name   Other names Salary

Smith   John    2000


Retrieving Smith & Andy Denton by Salary <= 5000:
Last Name   Other names Salary

Denton  Andy    5000
Smith   John    2000


Retrieving Taylor & Trissa Dent by Salary > 5000:
Last Name   Other names Salary

Taylor  Ken 7500
DENT    Trissa  9999


Same search with >=5000 (should also get Andy Denton):
Last Name   Other names Salary

Denton  Andy    5000
Taylor  Ken 7500
DENT    Trissa  9999


Finding Salary between 5000 and 7500
Last Name   Other names Salary

Denton  Andy    5000
Taylor  Ken 7500


Finding Salary outside 5000 to 7500
Last Name   Other names Salary

Smith   John    2000
DENT    Trissa  9999


done
Dumping database in key order by Salary NoDup
Last Name   Other names Salary NoDup

Smith   John    2000
Denton  Andy    5000
Taylor  Ken 7500
DENT    Trissa  9999


Retrieving Andy Denton by Salary NoDup = 5000:
Last Name   Other names Salary NoDup



Retrieving John Smith by Salary NoDup < 5000:
Last Name   Other names Salary NoDup

Smith   John    2000


Retrieving Smith & Andy Denton by Salary NoDup <= 5000:
Last Name   Other names Salary NoDup

Denton  Andy    5000
Smith   John    2000


Retrieving Taylor & Trissa Dent by Salary NoDup > 5000:
Last Name   Other names Salary NoDup

Taylor  Ken 7500
DENT    Trissa  9999


Same search with >=5000 (should also get Andy Denton):
Last Name   Other names Salary NoDup

Denton  Andy    5000
Taylor  Ken 7500
DENT    Trissa  9999


Finding Salary NoDup between 5000 and 7500
Last Name   Other names Salary NoDup

Denton  Andy    5000
Taylor  Ken 7500


Finding Salary NoDup outside 5000 to 7500
Last Name   Other names Salary NoDup

Smith   John    2000
DENT    Trissa  9999


done
Dumping database in key order by SalaryReal
Last Name   Other names SalaryReal

Smith   John    2000
Denton  Andy    5000
Taylor  Ken 7500
DENT    Trissa  9999


Retrieving Andy Denton by SalaryReal = 5000:
Last Name   Other names SalaryReal

Denton  Andy    5000


Retrieving John Smith by SalaryReal < 5000:
Last Name   Other names SalaryReal

Smith   John    2000


Retrieving Smith & Andy Denton by SalaryReal <= 5000:
Last Name   Other names SalaryReal

Denton  Andy    5000
Smith   John    2000


Retrieving Taylor & Trissa Dent by SalaryReal > 5000:
Last Name   Other names SalaryReal

Taylor  Ken 7500
DENT    Trissa  9999


Same search with >=5000 (should also get Andy Denton):
Last Name   Other names SalaryReal

Denton  Andy    5000
Taylor  Ken 7500
DENT    Trissa  9999


Finding SalaryReal between 5000 and 7500
Last Name   Other names SalaryReal

Denton  Andy    5000
Taylor  Ken 7500


Finding SalaryReal outside 5000 to 7500
Last Name   Other names SalaryReal

Smith   John    2000
DENT    Trissa  9999


done
Dumping database in key order by SalaryRealNoDup
Last Name   Other names SalaryRealNoDup

Smith   John    2000
Denton  Andy    5000
Taylor  Ken 7500
DENT    Trissa  9999


Retrieving Andy Denton by SalaryRealNoDup = 5000:
Last Name   Other names SalaryRealNoDup



Retrieving John Smith by SalaryRealNoDup < 5000:
Last Name   Other names SalaryRealNoDup

Smith   John    2000


Retrieving Smith & Andy Denton by SalaryRealNoDup <= 5000:
Last Name   Other names SalaryRealNoDup

Denton  Andy    5000
Smith   John    2000


Retrieving Taylor & Trissa Dent by SalaryRealNoDup > 5000:
Last Name   Other names SalaryRealNoDup

Taylor  Ken 7500
DENT    Trissa  9999


Same search with >=5000 (should also get Andy Denton):
Last Name   Other names SalaryRealNoDup

Denton  Andy    5000
Taylor  Ken 7500
DENT    Trissa  9999


Finding SalaryRealNoDup between 5000 and 7500
Last Name   Other names SalaryRealNoDup

Denton  Andy    5000
Taylor  Ken 7500


Finding SalaryRealNoDup outside 5000 to 7500
Last Name   Other names SalaryRealNoDup

Smith   John    2000
DENT    Trissa  9999


done
Dumping database in key order by LastVisit
Last Name   Other names LastVisit

DENT    Trissa  22/11/1994 0:00:00
Smith   John    23/11/1994 0:00:00
Denton  Andy    23/1/1995 0:00:00
Taylor  Ken 16/11/1995 0:00:00


Finding LastVisit == 23/11/94
Last Name   Other names LastVisit

Smith   John    23/11/1994 0:00:00


Finding LastVisit < 23/11/94
Last Name   Other names LastVisit

DENT    Trissa  22/11/1994 0:00:00


Finding LastVisit <= 23/11/94
Last Name   Other names LastVisit

Smith   John    23/11/1994 0:00:00
DENT    Trissa  22/11/1994 0:00:00


Finding LastVisit > 23/11/94
Last Name   Other names LastVisit

Denton  Andy    23/1/1995 0:00:00
Taylor  Ken 16/11/1995 0:00:00


Finding LastVisit >= 23/11/94
Last Name   Other names LastVisit

Smith   John    23/11/1994 0:00:00
Denton  Andy    23/1/1995 0:00:00
Taylor  Ken 16/11/1995 0:00:00


Finding LastVisit between 23/11/94 and 23-1-95
Last Name   Other names LastVisit

Smith   John    23/11/1994 0:00:00
Denton  Andy    23/1/1995 0:00:00


Finding LastVisit outside 23/11/94 to 23-1-95
Last Name   Other names LastVisit

DENT    Trissa  22/11/1994 0:00:00
Taylor  Ken 16/11/1995 0:00:00


Dumping database in key order by LastVisitNoDup
Last Name   Other names LastVisitNoDup

DENT    Trissa  22/11/1994 0:00:00
Smith   John    23/11/1994 0:00:00
Denton  Andy    23/1/1995 0:00:00
Taylor  Ken 16/11/1995 0:00:00


Finding LastVisitNoDup == 23/11/94
Last Name   Other names LastVisitNoDup

Smith   John    23/11/1994 0:00:00


Finding LastVisitNoDup < 23/11/94
Last Name   Other names LastVisitNoDup

DENT    Trissa  22/11/1994 0:00:00


Finding LastVisitNoDup <= 23/11/94
Last Name   Other names LastVisitNoDup

Smith   John    23/11/1994 0:00:00
DENT    Trissa  22/11/1994 0:00:00


Finding LastVisitNoDup > 23/11/94
Last Name   Other names LastVisitNoDup

Denton  Andy    23/1/1995 0:00:00
Taylor  Ken 16/11/1995 0:00:00


Finding LastVisitNoDup >= 23/11/94
Last Name   Other names LastVisitNoDup

Smith   John    23/11/1994 0:00:00
Denton  Andy    23/1/1995 0:00:00
Taylor  Ken 16/11/1995 0:00:00


Finding LastVisitNoDup between 23/11/94 and 22-1-95
Last Name   Other names LastVisitNoDup

Smith   John    23/11/1994 0:00:00


Finding LastVisitNoDup outside 23/11/94 to 22-1-95
Last Name   Other names LastVisitNoDup

DENT    Trissa  22/11/1994 0:00:00
Denton  Andy    23/1/1995 0:00:00
Taylor  Ken 16/11/1995 0:00:00


done